﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MaxLeaf.Platform.Contract;
using MaxLeaf.Platform.DataContract;
using CommonsLib.DB;
using System.Transactions;
using System.Data.SqlClient;
using System.Data.Common;
using System.Diagnostics;
using CommonsLib.Settings;
using System.Data;

using System.Security.Cryptography;
using MaxLeaf.Platform.Functions;
using MaxLeaf.Platform.Commons;

namespace MaxLeaf.Platform.DALImplementation
{
    public class imUsingListDAL :BaseDAL 
    {


        public void SetPosted(DBAccess dbcon, int intKey, int intReqHdrId, int intReqDtlId)
        {
            string strSql = "update imUsingList set posted=1 ,StoresReqHdrId=@ReqHdrId,StoresReqDtlId=@ReqDtlId where FInterID=@FInterID and posted=0 and is_delete=0 ";
            dbcon.ExecuteSql(strSql, new SqlParameter[] { new SqlParameter("@FInterID", intKey.ToString())
                ,new SqlParameter("@ReqHdrId", intReqHdrId.ToString())
                ,new SqlParameter("@ReqDtlId", intReqDtlId.ToString())
            });
        }
    }
}
